Change the Number of SQL Server Error Logs (Windows NT/2000/XP)

Registry Guide for Windows
Part of the WinGuides Network

Registry tweaks, tricks & hacks to optimize, enhance and secure Microsoft Windows.

Change the Number of SQL Server Error Logs (Windows NT/2000/XP)
Category: Home > Windows > Troubleshooting > Logging

This tweak can be easily applied using WinGuides Tweak Manager.
Download a free trial now!

By default, Microsoft SQL Server 7.0 only stores seven error logs; Errorlog and Errorlog.1 through Errorlog.6. Since the log is re-created every time SQL Server is restarted you may want to keep more than seven logs archived.

Open your registry and find the key below.

Create a new DWORD value called 'NumErrorLogs' and set it to equal the number of archived logs you want to keep.

You may need to restart SQL for the change to become effective.


(Default)	REG_SZ	(value not set)
NumErrorLogs	REG_DWORD	0x00000014 (20)


	HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer

Settings:

System Key: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer]
Name: NumErrorLogs
Type: REG_DWORD (DWORD Value)
Value: default = 7

Disclaimer: Modifying the registry can cause serious problems that may require you to reinstall your operating system. We cannot guarantee that problems resulting from modifications to the registry can be solved. Use the information provided at your own risk.

Last Modified: September 5, 2000

Return to Index